Problemas com openjpa

16 respostas
C

CENÁRIO

Estrutura do Projeto
*****************************

jpa-openjpa
..src
....sessa.claudney.jpa.openjpa
......GenerateDatabase.java
......User.java
..META-INF
....persistence.xml
..JRE System Library
......
......
......
Referenced libraries
......
......
......
..lib
....commons-collections-32.jar
....commons-lang-2.1.jar
....commons-pool-1.3.jar
....geronimo-jpa_3.0_spec-1.0.jar
....geronimo-jta_1.1_spec-1.1.jar
....mysql-connector-java-5.1.8-bin.jar
....openjpa-1.2.1.jar
....serp-1.13.1.jar

PERSISTENCE.XML

<?xml version="1.0" encoding="UTF-8"?>
  <persistence xmlns="http://java.sun.com/xml/ns/persistence"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0"
  xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
  <persistence-unit transaction-type="RESOURCE_LOCAL" name="jpa-openjpa">
  <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> 
  <exclude-unlisted-classes>false</exclude-unlisted-classes>
     <properties>
		<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/jpa_openjpa"/>
		<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
		<property name="openjpa.ConnectionUserName" value="root"/>
		<property name="openjpa.ConnectionPassword" value="123456"/>
		<property name="openjpa.Log" value="DefaultLevel=WARN,Tool=INFO"/>
		<property name="openjpa.jdbc.DBDictionary" value="mysql" />
		<property name="openjpa.Log" value="DefaultLevel=INFO" />
     </properties>   
    </persistence-unit>   
</persistence>

User.java

package sessa.claudney.jpa.openjpa;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {

	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private long id;
	
	@Column(name="full_name")	
	private String name;
	
	@Column(length=50)
	private String login;
	
	@Column(name="pwd",length=40)	
	private String password;
	
	public long getId() {
		return id;
	}
	
	//Será utilizado via notação
	// I want need it!
	//public void setId(long id) {
	//	this.id = id;
	//}
	
	public String getName() {
		return name;
	}
	
	public void setName(String name) {
		this.name = name;
	}
	
	public String getLogin() {
		return login;
	}
	
	public void setLogin(String login) {
		this.login = login;
	}
	
	public String getPassword() {
		return password;
	}
	
	public void setPassword(String password) {
		this.password = password;
	}	
	
}

GenerateDatabase.java

package sessa.claudney.jpa.openjpa;

import java.util.Properties;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class GenerateDatabase {

	public static void main(String[] args) {

		Properties cfg = new Properties();
		cfg.setProperty("openjpa.ddl-generation" ,"drop-and-create-tables");		
		EntityManagerFactory emf= Persistence.createEntityManagerFactory("jpa-openjpa",cfg);
		EntityManager em = emf.createEntityManager();
		
		em.close();  //Fechando o EntityManager
		emf.close(); //Fechando o EntityManagerFactory
		
	}	
	
}

ERRO:

10  jpa-openjpa  WARN   [main] openjpa.Runtime - The configuration property named "openjpa.ddl-generation" was not recognized and will be ignored, although the name closely matches a valid property called "openjpa.ManagedRuntime".
90  jpa-openjpa  INFO   [main] openjpa.Runtime - Starting OpenJPA 1.2.1
231  jpa-openjpa  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".

16 Respostas

F

Olá claudneysessa, se você ainda não foi saudado: Seja bem vindo ao GUJ! :D

Rapaz, deixa eu te dar um conselho: Coloque seu código entre as tags [code] [/code].
Se você deixá-lo assim como está, muito pouca gente vai tentar lê-lo a fim de ajudar.

Aqui tem essa e mais algumas instruções para os novos integrantes da comunidade.

É isso aí, um abraço! :wink:

I

Bom Dia,

Poderia postar a descrição do ERRO com mais detalhes?

Abraços.

C

[size=18][color=blue]GRATO PELA AJUDA AGORA SEGUE O CÓDIGO FORMATADO....
ESPERO QUE MAIS GENTE TENTE ME AJUDAR AGORA....[/color]
[/size]

[size=18]CARA QUE EU QUE QUERIA MESMO MELHORAR A FORMA COM QUE O ERRO É APRESENTADA MAIS É ASSIM MESMO QUE ESTA APARECENDO NO MEU ECLIPSE SÓ ESTAS DUAS LINHAS.....
ENGRAÇADO É QUE EU FIZ O TESTE COM O ECLIPSELINK, COM O TOPLINK-ESSENTIALS E COM O HIBERNATE E FUNCIONOU....
[/size]

CENÁRIO

PERSISTENCE.XML

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlnssi="http://www.w3.org/2001/XMLSchema-instance" version="1.0"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit transaction-type="RESOURCE_LOCAL" name="jpa-openjpa">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/jpa_openjpa"/>
<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
<property name="openjpa.ConnectionUserName" value="root"/>
<property name="openjpa.ConnectionPassword" value="123456"/>
<property name="openjpa.Log" value="DefaultLevel=WARN,Tool=INFO"/>
<property name="openjpa.jdbc.DBDictionary" value="mysql(SupportsSubselect=true)" />
<property name="openjpa.Log" value="DefaultLevel=INFO" />
</properties>
</persistence-unit>
</persistence>
User.java


package sessa.claudney.jpa.openjpa;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;

@Column(name="full_name")
private String name;

@Column(length=50)
private String login;

@Column(name="pwd",length=40)
private String password;

public long getId() {
return id;
}

//Será utilizado via notação
// I want need it!
//public void setId(long id) {
// this.id = id;
//}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getLogin() {
return login;
}

public void setLogin(String login) {
this.login = login;
}

public String getPassword() {
return password;
}

public void setPassword(String password) {
this.password = password;
}

}
GenerateDatabase.java

package sessa.claudney.jpa.openjpa;

import java.util.Properties;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class GenerateDatabase {

	public static void main(String[] args) {

		Properties cfg = new Properties();
		cfg.setProperty("openjpa.ddl-generation" ,"drop-and-create-tables");		
		EntityManagerFactory emf= Persistence.createEntityManagerFactory("jpa-openjpa",cfg);
		EntityManager em = emf.createEntityManager();
		
		em.close();  //Fechando o EntityManager
		emf.close(); //Fechando o EntityManagerFactory
		
	}	
	
}
ERRO:

10  jpa-openjpa  WARN   [main] openjpa.Runtime - The configuration property named "openjpa.ddl-generation" was not recognized and will be ignored, although the name closely matches a valid property called "openjpa.ManagedRuntime".
90  jpa-openjpa  INFO   [main] openjpa.Runtime - Starting OpenJPA 1.2.1
231  jpa-openjpa  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".
C

IAX:
Bom Dia,

Poderia postar a descrição do ERRO com mais detalhes?

Abraços.

[size=12]
CARA QUE EU QUE QUERIA MESMO MELHORAR A FORMA COM QUE O ERRO É APRESENTADA…
MAIS É ASSIM MESMO QUE ESTA APARECENDO NO MEU ECLIPSE SÓ ESTAS DUAS LINHAS…
ENGRAÇADO É QUE EU FIZ O TESTE COM O ECLIPSELINK, COM O TOPLINK-ESSENTIALS E COM O HIBERNATE E FUNCIONOU…
SÓ O OPENJPA QUE ESTA ME SACANEANDO AGORA…
[/size]

C

[color=red]
OU É MUITO COMPLICADO E NINGUEM SABE OU É MUITA MÁ VONTADE …
VLW…
MELHOR EU LARGAR ESTE PAPO DE FÓRUM E IR APRENDER SOZINHO…
[/color]

G

Claudinei, todos aqui ajudam conforme podem. Ninguém está de má vontade não. Talvez não saibamos como te ajudar. Atitudes assim de chutar o pau da barraca tornam o fórum um pouco desagradável.

Mas vamos lá… há muito poucas informações para poder te ajudar. O melhor a fazer por enquanto é aumentar o nível de log alterando a linha:

para

Uma outra sugestão é tentar descrever para nós o comportamento. Não sobe a app, não cria as tabelas… ou enfim, o que está acontecendo afinal?

Abraços

C

claudneysessa:
[color=red][b]

OU É MUITO COMPLICADO
OU NINGUEM SABE OU É MUITA MÁ VONTADE …
VLW…
MELHOR EU LARGAR ESTE PAPO DE FÓRUM E IR APRENDER SOZINHO…

[/b][/color]

O FÓRUM É SHOW…
ESTOU BUSCANDO EM VÁRIAS FONTES COMO RESOLVER…
DESCULPE SE ACABEI ESCREVENDO A MAIS, É QUE DE VEZ ENQUANTO É OSSO…

C

O QUE EU TENHO AGORA É:

<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/percistence persistence_1_0.xsd" version="1.0">
  <persistence-unit name="jpa-openjpa">
  <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
  <class>sessa.claudney.jpa.openjpa.User</class>
    <properties>
      <property name="openjpa.jdbc.DBDictionary" value="mysql(SupportsSubselect=true)"/>
      <property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost/jpa_openjpa"/>
      <property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
      <property name="openjpa.ConnectionUserName" value="root"/>
      <property name="openjpa.ConnectionPassword" value="123456"/>
      <property name="openjpa.Log" value="DefaultLevel=DEBUG, Tool=DEBUG"/>
    </properties>
  </persistence-unit>
</persistence>

O ERRO É:

Exception in thread "main" javax.persistence.PersistenceException: Provider error. Provider: org.apache.openjpa.persistence.PersistenceProviderImpl
	at javax.persistence.Persistence.createFactory(Persistence.java:175)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:111)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:65)
	at sessa.claudney.jpa.openjpa.GenerateDatabase.main(GenerateDatabase.java:17)
Caused by: <openjpa-1.2.1-r752877:753278 fatal general error> org.apache.openjpa.persistence.PersistenceException: There was an error when invoking the static newInstance method on the named factory class "org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory".  See the nested exception for details.
	at org.apache.openjpa.kernel.Bootstrap.newBrokerFactory(Bootstrap.java:67)
	at org.apache.openjpa.persistence.PersistenceProviderImpl.getBrokerFactory(PersistenceProviderImpl.java:102)
	at org.apache.openjpa.persistence.PersistenceProviderImpl.createEntityManagerFactory(PersistenceProviderImpl.java:81)
	at org.apache.openjpa.persistence.PersistenceProviderImpl.createEntityManagerFactory(PersistenceProviderImpl.java:109)
	at org.apache.openjpa.persistence.PersistenceProviderImpl.createEntityManagerFactory(PersistenceProviderImpl.java:53)
	at javax.persistence.Persistence.createFactory(Persistence.java:171)
	... 3 more
Caused by: org.apache.openjpa.lib.util.ParseException: [email removido] = DEBUG
	at org.apache.openjpa.lib.util.Options.setInto(Options.java:237)
	at org.apache.openjpa.lib.util.Options.setInto(Options.java:190)
	at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:476)
	at org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:430)
	at org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:103)
	at org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83)
	at org.apache.openjpa.lib.conf.ConfigurationImpl.getLogFactory(ConfigurationImpl.java:206)
	at org.apache.openjpa.lib.conf.ConfigurationImpl.getLog(ConfigurationImpl.java:223)
	at org.apache.openjpa.conf.OpenJPAConfigurationImpl.getConfigurationLog(OpenJPAConfigurationImpl.java:1445)
	at org.apache.openjpa.persistence.PersistenceProductDerivation$ConfigurationProviderImpl.setInto(PersistenceProductDerivation.java:479)
	at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newInstance(JDBCBrokerFactory.java:61)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.openjpa.kernel.Bootstrap.invokeFactory(Bootstrap.java:124)
	at org.apache.openjpa.kernel.Bootstrap.newBrokerFactory(Bootstrap.java:62)
	... 8 more
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.openjpa.lib.util.Options.invoke(Options.java:401)
	at org.apache.openjpa.lib.util.Options.setInto(Options.java:234)
	... 24 more
Caused by: java.lang.IllegalArgumentException: The log level string "DEBUG" is not valid. Valid values are TRACE, INFO, WARN, ERROR or FATAL.
	at org.apache.openjpa.lib.log.LogFactoryImpl.getLevel(LogFactoryImpl.java:252)
	at org.apache.openjpa.lib.log.LogFactoryImpl.setDefaultLevel(LogFactoryImpl.java:132)
	... 30 more
G
Altere o nível de log para TRACE ao invés de debug.

Altere o nível de log para TRACE ao invés de debug.

C

Gerou um log muito extenso....

0  jpa-openjpa  TRACE  [main] openjpa.Runtime - Setting the following properties from "file:/D:/Eclipse%20Workspace/jpa-openjpa/bin/META-INF/persistence.xml" 
into configuration: {openjpa.BrokerFactory=jdbc, openjpa.ConnectionPassword=123456, 
openjpa.ConnectionDriverName=com.mysql.jdbc.Driver, javax.persistence.provider=org.apache.openjpa.persistence.PersistenceProviderImpl, openjpa.MetaDataFactory=jpa(Types=sessa.claudney.jpa.openjpa.User), openjpa.Log=DefaultLevel=TRACE, 
Tool=TRACE, openjpa.jdbc.DBDictionary=mysql(SupportsSubselect=true), 
openjpa.ConnectionUserName=root, openjpa.ConnectionURL=jdbc:mysql://localhost/jpa_openjpa, openjpa.Id=jpa-openjpa}
90  jpa-openjpa  INFO   [main] openjpa.Runtime - Starting OpenJPA 1.2.1
90  jpa-openjpa  TRACE  [main] openjpa.Runtime - Properties: openjpa.DataCacheManager: default
openjpa.BrokerFactory: jdbc
openjpa.EntityManagerFactory: default
openjpa.ConnectionRetainMode: on-demand
openjpa.DataCacheTimeout: -1
openjpa.NontransactionalWrite: true
openjpa.IgnoreChanges: false
openjpa.FetchGroups: default
openjpa.jdbc.SubclassFetchMode: join
openjpa.jdbc.FetchDirection: forward
openjpa.InverseManager: false
openjpa.MaxFetchDepth: -1
openjpa.Compatibility: default
openjpa.ConnectionFactoryMode: local
openjpa.RetryClassRegistration: false
openjpa.jdbc.SynchronizeMappings: false
openjpa.jdbc.Schemas: 
openjpa.AutoClear: datastore
openjpa.FetchBatchSize: -1
openjpa.ProxyManager: default
openjpa.OrphanedKeyAction: log
openjpa.ConnectionURL: jdbc:mysql://localhost/jpa_openjpa
openjpa.Multithreaded: false
openjpa.SavepointManager: in-mem
openjpa.Optimistic: true
openjpa.jdbc.EagerFetchMode: parallel
openjpa.jdbc.DBDictionary: mysql(SupportsSubselect=true)
openjpa.Log: DefaultLevel=TRACE, Tool=TRACE
openjpa.ConnectionUserName: root
openjpa.QueryCompilationCache: true
openjpa.jdbc.QuerySQLCache: true
openjpa.jdbc.LRSSize: query
openjpa.ManagedRuntime: auto
openjpa.ConnectionDriverName: com.mysql.jdbc.Driver
openjpa.jdbc.ResultSetType: forward-only
openjpa.LockTimeout: -1
openjpa.MetaDataFactory: jpa(Types=sessa.claudney.jpa.openjpa.User)
openjpa.jdbc.DriverDataSource: simple
openjpa.DataCache: false
openjpa.WriteLockLevel: write
openjpa.RefreshFromDataCache: false
openjpa.RuntimeUnenhancedClasses: supported
openjpa.MetaDataRepository: default
openjpa.jdbc.SchemaFactory: dynamic
openjpa.jdbc.TransactionIsolation: default
openjpa.ConnectionPassword: 123456
openjpa.FlushBeforeQueries: true
openjpa.TransactionMode: local
openjpa.AutoDetach: 
openjpa.ClassResolver: default
openjpa.jdbc.MappingDefaults: jpa
openjpa.DetachState: loaded
openjpa.RetainState: true
openjpa.DynamicDataStructs: false
openjpa.NontransactionalRead: true
openjpa.jdbc.UpdateManager: default
openjpa.LockManager: version
openjpa.ReadLockLevel: read
openjpa.QueryCache: true
openjpa.Id: jpa-openjpa
openjpa.jdbc.SQLFactory: default
openjpa.BrokerImpl: default
openjpa.Sequence: table
openjpa.RestoreState: immutable
100  jpa-openjpa  TRACE  [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance.
270  jpa-openjpa  TRACE  [main] openjpa.MetaData - Using metadata factory "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1ff7a1e".
330  jpa-openjpa  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".
451  jpa-openjpa  TRACE  [main] openjpa.jdbc.JDBC - DataSource connection setAutoCommit to "false"
811  jpa-openjpa  TRACE  [main] openjpa.jdbc.JDBC - catalogSeparator: .
catalogTerm: database
databaseProductName: MySQL
databaseProductVersion: 5.1.37-community
driverName: MySQL-AB JDBC Driver
driverVersion: mysql-connector-java-5.1.8 ( Revision: ${svn.Revision} )
extraNameCharacters: #@
identifierQuoteString: `
numericFunctions: ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE
procedureTerm: PROCEDURE
schemaTerm: 
searchStringEscape: \
sqlKeywords: ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,
DAY_MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,
FORCE,FULLTEXT,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,
ITERATE,KEYS,KILL,LEAVE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,
MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,OPTIMIZE,
OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,SCHEMAS,
SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,
SSL,STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,
VARBINARY,VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL
stringFunctions: ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,
INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,
REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
systemFunctions: DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
timeDateFunctions: DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,
PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,
CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
url: jdbc:mysql://localhost/jpa_openjpa
userName: root@localhost
defaultTransactionIsolation: 2
driverMajorVersion: 5
driverMinorVersion: 1
maxBinaryLiteralLength: 16777208
maxCatalogNameLength: 32
maxCharLiteralLength: 16777208
maxColumnNameLength: 64
maxColumnsInGroupBy: 64
maxColumnsInIndex: 16
maxColumnsInOrderBy: 64
maxColumnsInSelect: 256
maxColumnsInTable: 512
maxConnections: 0
maxCursorNameLength: 64
maxIndexLength: 256
maxProcedureNameLength: 0
maxRowSize: [telefone removido]
maxSchemaNameLength: 0
maxStatementLength: 65531
maxStatements: 0
maxTableNameLength: 64
maxTablesInSelect: 256
maxUserNameLength: 16
isCatalogAtStart: true
isReadOnly: false
nullPlusNonNullIsNull: true
nullsAreSortedAtEnd: false
nullsAreSortedAtStart: false
nullsAreSortedHigh: false
nullsAreSortedLow: true
storesLowerCaseIdentifiers: true
storesLowerCaseQuotedIdentifiers: true
storesMixedCaseIdentifiers: false
storesMixedCaseQuotedIdentifiers: false
storesUpperCaseIdentifiers: false
storesUpperCaseQuotedIdentifiers: true
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsANSI92EntryLevelSQL: true
supportsANSI92FullSQL: false
supportsANSI92IntermediateSQL: false
supportsCatalogsInDataManipulation: true
supportsCatalogsInIndexDefinitions: true
supportsCatalogsInPrivilegeDefinitions: true
supportsCatalogsInProcedureCalls: true
supportsCatalogsInTableDefinitions: true
supportsColumnAliasing: true
supportsConvert: false
supportsCoreSQLGrammar: true
supportsCorrelatedSubqueries: true
supportsDataDefinitionAndDataManipulationTransactions: false
supportsDataManipulationTransactionsOnly: false
supportsDifferentTableCorrelationNames: true
supportsExpressionsInOrderBy: true
supportsExtendedSQLGrammar: false
supportsFullOuterJoins: false
supportsGroupBy: true
supportsGroupByBeyondSelect: true
supportsGroupByUnrelated: true
supportsIntegrityEnhancementFacility: false
supportsLikeEscapeClause: true
supportsLimitedOuterJoins: true
supportsMinimumSQLGrammar: true
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: false
supportsMultipleResultSets: false
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: false
supportsOpenStatementsAcrossRollback: false
supportsOrderByUnrelated: false
supportsOuterJoins: true
supportsPositionedDelete: false
supportsPositionedUpdate: false
supportsSchemasInDataManipulation: false
supportsSchemasInIndexDefinitions: false
supportsSchemasInPrivilegeDefinitions: false
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: false
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsTableCorrelationNames: true
supportsTransactions: true
supportsUnion: true
supportsUnionAll: true
usesLocalFilePerTable: false
usesLocalFiles: false
allProceduresAreCallable: false
allTablesAreSelectable: false
dataDefinitionCausesTransactionCommit: true
dataDefinitionIgnoredInTransactions: false
doesMaxRowSizeIncludeBlobs: true
supportsBatchUpdates: true
831  jpa-openjpa  TRACE  [main] openjpa.jdbc.JDBC - Initial connection autoCommit: false, holdability: 2, TransactionIsolation: 4
841  jpa-openjpa  TRACE  [main] openjpa.jdbc.JDBC - <t 24569170, conn 17478435> [10 ms] close
911  jpa-openjpa  TRACE  [main] openjpa.MetaData - Scanning resource "META-INF/orm.xml" for persistent types.
911  jpa-openjpa  TRACE  [main] openjpa.MetaData - parsePersistentTypeNames() found [sessa.claudney.jpa.openjpa.User].
911  jpa-openjpa  TRACE  [main] openjpa.MetaData - Found 1 classes with metadata in 10 milliseconds.
1041  jpa-openjpa  INFO   [main] openjpa.Enhance - Creating subclass for "[class sessa.claudney.jpa.openjpa.User]". This means that your application will be less efficient and will consume more memory than it would if you ran the OpenJPA enhancer. Additionally, lazy loading will not be available for one-to-one and many-to-one persistent attributes in types using field access; they will be loaded eagerly instead.
1142  jpa-openjpa  TRACE  [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance.
1142  jpa-openjpa  TRACE  [main] openjpa.MetaData - Using metadata factory "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@ac6a45".
1142  jpa-openjpa  TRACE  [main] openjpa.MetaData - Loading metadata for "class sessa.claudney.jpa.openjpa.User" under mode "[META]".
1142  jpa-openjpa  TRACE  [main] openjpa.MetaData - Scanning resource "META-INF/orm.xml" for persistent types.
1152  jpa-openjpa  TRACE  [main] openjpa.MetaData - parsePersistentTypeNames() found [sessa.claudney.jpa.openjpa.User].
1152  jpa-openjpa  TRACE  [main] openjpa.MetaData - Found 1 classes with metadata in 10 milliseconds.
1222  jpa-openjpa  TRACE  [main] openjpa.MetaData - Parsing class "sessa.claudney.jpa.openjpa.User".
1222  jpa-openjpa  TRACE  [main] openjpa.MetaData - Parsing package "sessa.claudney.jpa.openjpa.User".
1292  jpa-openjpa  TRACE  [main] openjpa.MetaData - Generating default metadata for type "sessa.claudney.jpa.openjpa.User".
1292  jpa-openjpa  TRACE  [main] openjpa.MetaData - Using reflection for metadata generation.
1332  jpa-openjpa  TRACE  [main] openjpa.MetaData - Set persistence-capable superclass of "sessa.claudney.jpa.openjpa.User" to "null".
1332  jpa-openjpa  TRACE  [main] openjpa.MetaData - Resolving metadata for "sessa.claudney.jpa.openjpa.User@23738549".
1332  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1362  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1362  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1362  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1362  jpa-openjpa  TRACE  [main] openjpa.MetaData - Preparing mapping for "sessa.claudney.jpa.openjpa.User".
1362  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1372  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"id" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"login" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"name" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"password" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User<discriminator>" has mapping strategy "none".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User<version>" has mapping strategy "none".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - Resolving mapping for "sessa.claudney.jpa.openjpa.User@23738549".
1382  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User" has mapping strategy "full".
1382  jpa-openjpa  TRACE  [main] openjpa.Enhance - Enhancing type "class sessa.claudney.jpa.openjpa.User".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Loading metadata for "class sessa.claudney.jpa.openjpa.User" under mode "[META][QUERY]".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Parsing class "sessa.claudney.jpa.openjpa.User".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Parsing package "sessa.claudney.jpa.openjpa.User".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Generating default metadata for type "sessa.claudney.jpa.openjpa.User".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Set persistence-capable superclass of "sessa.claudney.jpa.openjpa.User" to "null".
1452  jpa-openjpa  TRACE  [main] openjpa.MetaData - Resolving metadata for "sessa.claudney.jpa.openjpa.User@10313829".
1472  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1472  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1472  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1472  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - Preparing mapping for "sessa.claudney.jpa.openjpa.User".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - Processing registered persistence-capable class "class sessa.claudney.jpa.openjpa.User".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"id" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.PrimitiveFieldStrategy".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"login" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"name" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	"password" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.StringFieldStrategy".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User<discriminator>" has mapping strategy "none".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User<version>" has mapping strategy "none".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - Resolving mapping for "sessa.claudney.jpa.openjpa.User@10313829".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - "sessa.claudney.jpa.openjpa.User" has mapping strategy "full".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - Initializing mapping for "sessa.claudney.jpa.openjpa.User@10313829".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1482  jpa-openjpa  TRACE  [main] openjpa.MetaData - 	Resolving field "[email removido]".
1502  jpa-openjpa  TRACE  [main] openjpa.MetaData - Clearing metadata repository "org.apache.openjpa.jdbc.meta.MappingRepository@e66f56".
G

Não parece haver erro algum. Conforme os logs a aplicação sobe tranquilamente.

C

SOBE CORRETAMENTE?
VIXI TO PIOR DO QUE EU PENSAVA ENTÃO, NOS OUTROS TESTES ESTA APLICAÇÃO GEROU A TABELA NA MINHA BASE DE DADOS CONFORME A CLASSE USER QUE EU HAVIA CRIADO
SERÁ QUE FALTA ALGUMA COISA NO PERSISTENCE.XML ?

G

Na minha visão parece normal.

C

OK
VO QUEBRAR UM POUCO MAIS A CABEÇA AQUI PARA VER O POR QUE ELE NAO CRIOU A TABELA CONFORME A CLASSE
MUITO OBRIGADO PELA AJUDA…
DESCULPE QUALQUER COISA…

C

SEMPRE ME DA ESTA MSG:

80 jpa-openjpa INFO [main] openjpa.Runtime - Starting OpenJPA 1.2.1 210 jpa-openjpa INFO [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary".

G

Mas isso não é um erro, é uma informação, vide parametro INFO no inicio de tudo. Ele apenas está te avisando que está usando MySQL dialect.

Criado 8 de outubro de 2009
Ultima resposta 9 de out. de 2009
Respostas 16
Participantes 4