Eclipselink orm kütüphanesini kullanarak Sql Server veritabanından veri çekmek istiyorum fakat hata alıyorum.Main sınıfım aşağıda,

public static void main(String[] args)
{
        EntityManager entityManager =  
                Persistence.createEntityManagerFactory("HRPSPU").createEntityManager();

        List<Personnel> personnelList = entityManager.createQuery("Select p FROM Personnel p",Personnel.class).getResultList();

        for (Personnel personnel : personnelList)
        {
                System.out.println(personnel.getName());
        }
    }

ve hatada bu arkadaşlar,

SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/E:/tutorial/glassfish3/glassfish/modules/bean-validator.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/E:/tutorial/glassfish3/glassfish/modules/weld-osgi-bundle.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. Tem 31, 2012 11:44:51 PM org.hibernate.validator.util.Version INFO: Hibernate Validator 4.2.0.Final [EL Info]: 2012-07-31 23:44:51.929--ServerSession(451764492)--EclipseLink, version: Eclipse Persistence Services - 2.4.0.v20120608-r11652 [EL Info]: connection: 2012-07-31 23:44:52.951--ServerSession(451764492)--file:/E:/tutorial/workspace/HRPS/build/classes/_HRPSPU login successful [EL Warning]: 2012-07-31 23:44:53.927--UnitOfWork(1400947054)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Personnel'. Error Code: 208 Call: SELECT IdentificationNumber, Age, Name, Surname FROM Personnel Query: ReadAllQuery(referenceClass=Personnel sql="SELECT IdentificationNumber, Age, Name, Surname FROM Personnel") Exception in thread "main" Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Personnel'. Error Code: 208 Call: SELECT IdentificationNumber, Age, Name, Surname FROM Personnel Query: ReadAllQuery(referenceClass=Personnel sql="SELECT IdentificationNumber, Age, Name, Surname FROM Personnel") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:537) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1800) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:648) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2681) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2634) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:420) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1149) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:852) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1108) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:392) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1196) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2875) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1602) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1584) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1549) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:231) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:411) at entity.Main.main(Main.java:18) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Personnel'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:938) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:609) ... 22 more

integratedsecurity=true, kullanıcı ve şifre kullanmadan bağlantı kuruyorum.bu da persistance.xml

<persistence version="2.0" 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 &lt;a href=" http:="" java.sun.com="" xml="" ns="" persistence="" persistence_2_0.xsd"="">">http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> <persistence-unit name="HRPSPU" transaction-type="RESOURCE_LOCAL"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <class>entity.Personnel</class> <properties> <property name="javax.persistence.jdbc.url" value="jdbc:&lt;a href=" sqlserver:="" localhost:1433"="">sqlserver://localhost:1433;databaseName=Arge;integratedSecurity=true;"/> <property name="javax.persistence.jdbc.driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> <property name="javax.persistence.jdbc.password" value=""/> <property name="javax.persistence.jdbc.user" value=""/> </properties> </persistence-unit> </persistence>

IDE olarak Eclipse JUNO ve application sever olarak ise Glassfish kullanıyorum.. Önerileriniz varsa çok sevinirim herkese iyi akşamlar...

soruldu: 31 Tem '12, 17:02

salgul's gravatar image

salgul
45121816
cevap kabul oranı: 0%

1

Problemi çözdüm arkadaşlar.öncelikle iki tane olan jar'ı sildim.Daha sonrasında entity sınıfımızın annotation kısmına Table(name="örnek",schema="örnek",catalog="örnek") gibi ekleminiz gerekiyor.Bunun sebebi de ben kendi database'mi ve şemamı oluşturmuştum.kolay gelsin...

(01 Ağu '12, 14:48) salgul salgul's gravatar image

Hata ilk satirdan anlasiliyor:

SLF4J: Class path contains multiple SLF4J bindings...

birden cok SLF4J jar kullanilmis projede. zaten hata mesajindaki linkte de nasil cozulecegi anlatiliyor.

Fakat benim anlamadigim sey Glassfish ile web projesi yapiyorsaniz neden main methodu implement ettiginiz? Bildigim kadariyla web projelerinde main methodu kullanilmiyor! Proje yapinizi dikkatlice incelemenizi tavsiye ederim.

permanent link

cevaplandı: 01 Ağu '12, 05:06

CemIkta's gravatar image

CemIkta ♦
19.9k29125190
cevap kabul oranı: 36%

Sadece veri çekmeyi denemek için main metodunu kullandım yoksa gerçekte Main sınıfı ve metodu yok zaten.Sonuçta sadece orm aracının denenmesi içindi.Ayrıca sorunun application serverda olacağı aklıma gelmedi ben daha çok eclipselinkte hatayı aradım..İlginiz için teşekkür ederim.Verdiğiniz linke bakıyorum şimdi.

(01 Ağu '12, 05:23) salgul salgul's gravatar image
Cevabınız
toggle preview

Bu soruyu takip et

E-Posta üzerinden:

Üyelik girişi yaptıktan sonra abonelik işlemlerini yapabilirsiniz

RSS üzerinden:

Cevaplar

Cevaplar ve Yorumlar

Yazı Formatlama

  • *italic* ya da _italic_
  • **bold** ya da __bold__
  • link:[text](http://url.com/ "başlık")
  • resim?![alt text](/path/img.jpg "başlık")
  • liste: 1. Foo 2. Bar
  • temel HTML etiketleri de kullanılabilir

Bu sorunun etiketleri:

×86
×27
×10

Soruldu: 31 Tem '12, 17:02

Görüntüleme: 1,226 kez

Son güncelleme: 09 Ağu '12, 10:50

powered by BitNami OSQA