Ver Mensaje Individual
  #1 (permalink)  
Antiguo 24/08/2008, 16:24
AdRii
 
Fecha de Ingreso: agosto-2008
Mensajes: 96
Antigüedad: 15 años, 9 meses
Puntos: 3
Fallo en base de datos

Hola tengo una base de datos en la que tengo que guardar desde una aplicacion java un numero de jugadores un array de string con el nombre de los jugadores, cuando mete el nombre de jugadores solamente la aplicacion guarda y carga de la base de datos perfectamente, sin embargo cuando va a guardar la lista de string sale un error como este...

[TopLink Config]: 2008.08.25 12:20:28.593--ServerSession(11985823)--The alias name for the entity class [class UhuPoly.Guardar] is being defaulted to: Guardar.
[TopLink Config]: 2008.08.25 12:20:28.593--ServerSession(11985823)--The table name for entity [class UhuPoly.Guardar] is being defaulted to: GUARDAR.
[TopLink Config]: 2008.08.25 12:20:28.609--ServerSession(11985823)--The column name for element [private int UhuPoly.Guardar.NumJugadores] is being defaulted to: NUMJUGADORES.
[TopLink Config]: 2008.08.25 12:20:28.609--ServerSession(11985823)--The column name for element [private java.lang.String[] UhuPoly.Guardar.Jugadores] is being defaulted to: JUGADORES.
[TopLink Config]: 2008.08.25 12:20:28.609--ServerSession(11985823)--The column name for element [private java.lang.Long UhuPoly.Guardar.id] is being defaulted to: ID.
[TopLink Info]: 2008.08.25 12:20:28.843--ServerSession(11985823)--TopLink, version: Oracle TopLink Essentials - 2006.8 (Build 060830)
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(28623319)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(7364874)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(32708178)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(9744175)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(24737685)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(2799187)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(2633821)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(15774883)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(14894886)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(15308417)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(26740272)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(30617157)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(25358187)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> "user"
datasource URL=> "jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD"
))
[TopLink Config]: 2008.08.25 12:20:30.156--ServerSession(11985823)--Connection(3866500)--Connected: jdbc:derby:C:\Archivos de programa\eQuiPo A\UhuPoly\BD\UhuPolyBD
User: user
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Embedded JDBC Driver Version: 10.1.3.1
[TopLink Info]: 2008.08.25 12:20:30.250--ServerSession(11985823)--file:/C:/Documents%20and%20Settings/Administrador/Escritorio/PRACTICA%20IS2/UhuPolyJava/build/classes-UhuPolyJavaPU login successful
[TopLink Warning]: 2008.08.25 12:20:31.218--ServerSession(11985823)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseExcep tion
Internal Exception: SQL Exception: Table/View 'SEQUENCE' already exists in Schema 'USER'.Error Code: 30000
Call:CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL, PRIMARY KEY (SEQ_NAME))
Query:DataModifyQuery()
[TopLink Warning]: 2008.08.25 12:20:31.390--UnitOfWork(27071180)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseExcep tion
Internal Exception: SQL Exception: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '[Ljava.lang.String;'.Error Code: 20000
Call:INSERT INTO GUARDAR (ID, JUGADORES, NUMJUGADORES) VALUES (?, ?, ?)
bind => [1, [Ljava.lang.String;@13d1402, 2]
Query:InsertObjectQuery(Partida con 2 jugadores : )
javax.persistence.RollbackException: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseExcep tion
Internal Exception: SQL Exception: An attempt was made to get a data value of type 'VARCHAR' from a data value of type '[Ljava.lang.String;'.Error Code: 20000
Call:INSERT INTO GUARDAR (ID, JUGADORES, NUMJUGADORES) VALUES (?, ?, ?)
bind => [1, [Ljava.lang.String;@13d1402, 2]
Query:InsertObjectQuery(Partida con 2 jugadores : )
at oracle.toplink.essentials.internal.ejb.cmp3.transa ction.base.EntityTransactionImpl.commit(EntityTran sactionImpl.java:109)
at oracle.toplink.essentials.internal.ejb.cmp3.transa ction.EntityTransactionImpl.commit(EntityTransacti onImpl.java:45)
at UhuPoly.ControladorBD.persist(ControladorBD.java:3 1)

Nose de que puede ser, ya que e mirado varios manuales y guardan el array igual que yo..