java - 未找到值或 ?? 插入mysql时
问题描述
大家好,当我想将数据插入到 mydatabase 时,我遇到了问题...
insert into New_Single_Order_Response (AveragePrice, BodyLength, CheckSum, ClOrdID, CumQty, Currency, ExecID, ExecTransType, ExecType, Fix_Protocol, LastShares, LeavesQty, MsgSeqNum, MsgType, OrdStatus, OrdType, OrderID, OrderQty, SenderCompId, SendingTime, Side, Symbol, TargetCompID, TransactTime) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
但是我的数据无法插入到我的数据库中……为什么会这样?
首先我设置了我的 persistence.xml 使用
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="FastMatch" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<class>com.dxtr.hibernate.newOrderSingleEntity</class>
<properties>
<property name="eclipselink.logging.level" value="INFO"/>
<property name="eclipselink.logging.level.sql" value="FINE"/>
<property name="eclipselink.logging.parameters" value="true"/>
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://Url/dxtr_trades" />
<property name="javax.persistence.jdbc.user" value="username" />
<property name="javax.persistence.jdbc.password" value="password" />
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL57InnoDBDialect" />
<property name="hibernate.show_sql" value="true"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property name="eclipselink.logging.level.connection" value="FINEST"/>
</properties>
</persistence-unit>
</persistence>
这是我的实体
@Entity
@Table(name="New_Single_Order_Response")
public class newOrderSingleEntity implements Serializable{
private static final long serialVersionUID = -1234424538928L;
@Id
@Column(name="response_id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Integer id;
@Column(name="Fix_Protocol")
private String FixProtocol;
@Column(name="BodyLength")
private Integer BodyLength;
@Column(name="MsgSeqNum")
private Integer MsgSeqNum;
@Column(name="MsgType")
private String MsgType;
@Column(name="SenderCompId")
private String SenderCompId;
@Column(name="SendingTime")
private String SendingTime;
@Column(name="TargetCompID")
private String TargetCompID;
@Column(name="AveragePrice")
private Double AveragePrice;
@Column(name="ClOrdID")
private String ClOrdID;
@Column(name="CumQty")
private double CumQty;
@Column(name="Currency")
private String Currency;
@Column(name="ExecID")
private String ExecID;
@Column(name="LastShares")
private double LastShares;
@Column(name="OrderQty")
private Double OrderQty;
@Column(name="OrdStatus")
private String OrdStatus;
@Column(name="OrdType")
private String OrdType;
@Column(name="Side")
private Integer Side;
@Column(name="Symbol")
private String Symbol;
@Column(name="TransactTime")
private String TransactTime;
@Column(name="ExecType")
private String ExecType;
@Column(name="LeavesQty")
private double LeavesQty;
@Column(name="CheckSum")
private Integer CheckSum;
@Column(name="ExecTransType")
private String ExecTransType;
@Column(name="OrderID")
private String OrderID;
public Integer getResponse_ID() {
return this.id;
}
public void setResponse_ID(Integer id) {
this.id = id;
}
public String getFixProtocol() {
return this.FixProtocol;
}
public void setFixProtocol(String FixProtocol) {
this.FixProtocol = FixProtocol;
}
public Integer getBodyLength() {
return this.BodyLength;
}
public void setBodyLength(Integer BodyLength) {
this.BodyLength = BodyLength;
}
public Integer getMsgSeqNum() {
return this.MsgSeqNum;
}
public void setMsgSeqNum(Integer MsgSeqNum) {
this.MsgSeqNum = MsgSeqNum;
}
public String getMsgType() {
return this.MsgType;
}
public void setMsgType(String MsgType) {
this.MsgType = MsgType;
}
public String getSenderCompId() {
return this.SenderCompId;
}
public void setSenderCompId(String SenderCompId) {
this.SenderCompId = SenderCompId;
}
public String getSendingTime() {
return this.SendingTime;
}
public void setBodyLength(String SendingTime) {
this.SendingTime = SendingTime;
}
public String getTargetCompID() {
return this.TargetCompID;
}
public void setTargetCompID(String TargetCompID) {
this.TargetCompID = TargetCompID;
}
public Double getAveragePrice() {
return this.AveragePrice;
}
public void setAveragePrice(Double AveragePrice) {
this.AveragePrice = AveragePrice;
}
public String getClOrdID() {
return this.ClOrdID;
}
public void setClOrdID(String ClOrdID) {
this.ClOrdID = ClOrdID;
}
public double getCumQty() {
return this.CumQty;
}
public void setCumQty(double CumQty) {
this.CumQty = CumQty;
}
public String getCurrency() {
return this.Currency;
}
public void setCurrency(String Currency) {
this.Currency = Currency;
}
public String getExecID() {
return this.ExecID;
}
public void setExecID(String ExecID) {
this.ExecID = ExecID;
}
public double getLastShares() {
return this.LastShares;
}
public void setLastShares(double LastShares) {
this.LastShares = LastShares;
}
public Double getOrderQty() {
return this.OrderQty;
}
public void setOrderQty(Double OrderQty) {
this.OrderQty = OrderQty;
}
public String getExecType() {
return this.ExecType;
}
public void setExecType(String ExecType) {
this.ExecType = ExecType;
}
public String getOrdStatus() {
return this.OrdStatus;
}
public void setOrdStatus(String OrdStatus) {
this.OrdStatus = OrdStatus;
}
public String getOrdType() {
return this.OrdType;
}
public void setOrdType(String OrdType) {
this.OrdType = OrdType;
}
public Integer getSide() {
return this.Side;
}
public void setSide(Integer Side) {
this.Side = Side;
}
public String getSymbol() {
return this.Symbol;
}
public void setSymbol(String Symbol) {
this.Symbol = Symbol;
}
public String getTransactTime() {
return this.TransactTime;
}
public void setTransactTime(String TransactTime) {
this.TransactTime = TransactTime;
}
public double getLeavesQty() {
return this.LeavesQty;
}
public void setLeavesQty(double LeavesQty) {
this.LeavesQty = LeavesQty;
}
public Integer getCheckSum() {
return this.CheckSum;
}
public void setCheckSum(Integer CheckSum) {
this.CheckSum = CheckSum;
}
public String getExecTransType() {
return this.ExecTransType;
}
public void setExecTransType(String ExecTransType) {
this.ExecTransType = ExecTransType;
}
public String getOrderID() {
return this.OrderID;
}
public void setOrderID(String OrderID) {
this.OrderID = OrderID;
}
public String toString() {
return "OrderDetail?= Id: " + this.id + ", ClOrdID: " + this.ClOrdID + ", ExecID No.: " + this.ExecID + ", Symbol: " + this.Symbol;
}
}
这是我插入数据库的代码
newOrderSingleEntity newordersingleObj = new newOrderSingleEntity();
newordersingleObj.setSymbol(message.getString(Symbol.FIELD));
System.out.print(" symbol "+message.getString(Symbol.FIELD));
newordersingleObj.setMsgType(tipeMessage);
System.out.print(" tipeMessage "+tipeMessage);
newordersingleObj.setBodyLength(216);
System.out.print(" Body Length "+216);
newordersingleObj.setFixProtocol("FIX.4.2");
System.out.print("FixProtocol +FIX.4.2");
newordersingleObj.setTransactTime(message.getString(TransactTime.FIELD));
System.out.print(" time " +message.getString(TransactTime.FIELD));
newordersingleObj.setClOrdID(message.getString(ClOrdID.FIELD));
System.out.print(" ClOrdID "+message.getString(ClOrdID.FIELD));
newordersingleObj.setOrderID(message.getString(OrderID.FIELD));
System.out.print(" OrderID "+message.getString(OrderID.FIELD));
newordersingleObj.setExecID(message.getString(ExecID.FIELD));
System.out.print(" ExecID "+message.getString(ExecID.FIELD));
newordersingleObj.setExecTransType(message.getString(ExecTransType.FIELD));
System.out.print(" ExecTransType "+message.getString(ExecTransType.FIELD));
newordersingleObj.setOrdType(message.getString(OrdType.FIELD));
System.out.print(" OrdType "+message.getString(OrdType.FIELD));
newordersingleObj.setExecType(message.getString(ExecType.FIELD));
System.out.print(" ExecType "+message.getString(ExecType.FIELD));
newordersingleObj.setOrdStatus(message.getString(OrdStatus.FIELD));
System.out.print(" OrdStatus "+message.getString(OrdStatus.FIELD));
newordersingleObj.setSide(message.getInt(Side.FIELD));
System.out.print(" Side "+message.getInt(Side.FIELD));
newordersingleObj.setOrderQty(message.getDouble(OrderQty.FIELD));
System.out.print(" OrderQty "+message.getDouble(OrderQty.FIELD));
newordersingleObj.setLeavesQty(message.getDouble(LeavesQty.FIELD));
System.out.print(" LeavesQty "+message.getDouble(LeavesQty.FIELD));
newordersingleObj.setCumQty(message.getDouble(CumQty.FIELD));
System.out.print(" CumQty "+message.getDouble(CumQty.FIELD));
newordersingleObj.setLastShares(message.getInt(LastShares.FIELD));
System.out.print(" LastQty "+message.getInt(LastShares.FIELD));
} catch (FieldNotFound e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
我曾经使用过这样的尝试捕获,但没有错误......我认为我的应用程序也无法运行我的休眠模式
当我记录我想要插入的值时,存在并且值不存在????那么我的问题到底是什么?以及如何解决我的问题?我想要做的是将该数据插入到 mydatabase mysql5.7
这是我在这里使用的图书馆
在我更改我的 mysqlconnector 后,我得到了类似的信息
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Mon Apr 13 08:28:46 UTC 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL $.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with exist$ng applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting us$SSL=false, or set useSSL=true and provide truststore for server certificate verification.
究竟是什么问题?
解决方案
在我使用 mysql 连接器 8 更新我的 mysql 连接器之后,然后在我的 persistence.xml 中使用之后,这是关闭的
推荐阅读
- rx-java2 - 如何使用 RxBleAndroid 使用相同的连接收听通知并发送写操作?
- c++ - OpenCV 中“\0”的值
- amazon-web-services - AWS Step Function - 等待后重新执行步骤
- caching - 例外:一天内服务调用次数过多:urlfetch
- java - Eclipse 注释处理未在类路径上找到类
- php - 创建 PHP 函数以在 .TXT 中搜索特定用户名和密码
- apache-spark - pyspark - 如何根据当前和前一行条件添加新列
- javascript - 如何使图像从屏幕上掉下来?
- matlab - MATLAB原始向量长度为“n”的子向量的最大和
- php - PhpStorm 结构搜索以在 foreach 循环中找到自分配